{
  "statement":"select COUNT(DISTINCT f.`becif_no`) as `VALUE`, dim2.`strategy_id_pdl` as `STRATEGY_ID_PDL` \nfrom  `hive`.`test_db`.`tbl_d` AS `f` LEFT OUTER JOIN `hive`.`test_db`.`tbl_b` AS `dim3` ON (`f`.`trace_id` = `dim3`.`trace_id`) AND (`f`.`dt` = `dim3`.`dt`) LEFT OUTER JOIN `hive`.`test_db`.`tbl_e` AS `dim2` ON (`f`.`strategy_id_pdl` = `dim2`.`strategy_id_pdl`) AND (`f`.`dt` = `dim2`.`dt`)\nwhere f.`DT` >= 20231007 and f.`DT` <= 20231105 \nand (((dim2.`strategy_id_pdl` <> '' or dim2.`strategy_id_pdl` is not null) )) group by dim2.`strategy_id_pdl` LIMIT 51000;\n",
  "table_meta":{
    "test_db.tbl_a":"CREATE EXTERNAL TABLE `tbl_a` (\n  `becif_no` varchar(1048576) NULL COMMENT \"\",\n  `type` varchar(1048576) NULL COMMENT \"\",\n  `strategy_id` varchar(1048576) NULL COMMENT \"\",\n  `strategy_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `uv` bigint(20) NULL COMMENT \"\",\n  `data_year` varchar(1048576) NULL COMMENT \"\",\n  `data_month` varchar(1048576) NULL COMMENT \"\",\n  `data_date` varchar(1048576) NULL COMMENT \"\",\n  `page_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `page_name_pdl` varchar(1048576) NULL COMMENT \"\",\n  `label_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `label_name_pdl` varchar(1048576) NULL COMMENT \"\",\n  `module_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `module_name_pdl` varchar(1048576) NULL COMMENT \"\",\n  `strategy_item_id` varchar(1048576) NULL COMMENT \"\",\n  `strategy_item_type` varchar(1048576) NULL COMMENT \"\",\n  `strategy_item_name` varchar(1048576) NULL COMMENT \"\",\n  `pv` bigint(20) NULL COMMENT \"\",\n  `channel_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `channel_name_pdl` varchar(1048576) NULL COMMENT \"\",\n  `product_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `product_type` varchar(1048576) NULL COMMENT \"\",\n  `product_name` varchar(1048576) NULL COMMENT \"\",\n  `platform_type` int(11) NULL COMMENT \"\",\n  `event_type` varchar(1048576) NULL COMMENT \"\",\n  `channel_id` varchar(1048576) NULL COMMENT \"\",\n  `prod1` varchar(1048576) NULL COMMENT \"\",\n  `prod2` varchar(1048576) NULL COMMENT \"\",\n  `prod3` varchar(1048576) NULL COMMENT \"\",\n  `travel_code` varchar(1048576) NULL COMMENT \"\",\n  `node_code` varchar(1048576) NULL COMMENT \"\",\n  `batch_id` varchar(1048576) NULL COMMENT \"\",\n  `scene_id` varchar(1048576) NULL COMMENT \"\",\n  `campaign_id` varchar(1048576) NULL COMMENT \"\",\n  `item_index_pdl` varchar(1048576) NULL COMMENT \"\",\n  `position_id` varchar(1048576) NULL COMMENT \"\",\n  `trace_id` varchar(1048576) NULL COMMENT \"\",\n  `channel_ato` varchar(1048576) NULL COMMENT \"\",\n  `strategy_type` varchar(1048576) NULL COMMENT \"\",\n  `team_indicator_code` varchar(1048576) NULL COMMENT \"\",\n  `task_indicator_code` varchar(1048576) NULL COMMENT \"\",\n  `cust_group_name` varchar(1048576) NULL COMMENT \"\",\n  `event_time` varchar(1048576) NULL COMMENT \"\",\n  `dt` varchar(1048576) NULL COMMENT \"\"\n) ENGINE=HIVE \nPROPERTIES (\n\"database\" = \"test_db\",\n\"table\" = \"tbl_a\",\n\"resource\" = \"hive\"\n);",
    "test_db.tbl_b":"CREATE EXTERNAL TABLE `tbl_b` (\n  `trace_id` varchar(1048576) NULL COMMENT \"\",\n  `strategy_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `page_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `module_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `product_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `team_indicator_code` varchar(1048576) NULL COMMENT \"\",\n  `task_indicator_code` varchar(1048576) NULL COMMENT \"\",\n  `log_type` varchar(1048576) NULL COMMENT \"\",\n  `travel_code` varchar(1048576) NULL COMMENT \"\",\n  `node_code` varchar(1048576) NULL COMMENT \"\",\n  `travel_team_indicator_code` varchar(1048576) NULL COMMENT \"\",\n  `travel_task_indicator_code` varchar(1048576) NULL COMMENT \"\",\n  `node_type` varchar(1048576) NULL COMMENT \"\",\n  `big_type` varchar(1048576) NULL COMMENT \"\",\n  `batch_id` varchar(1048576) NULL COMMENT \"\",\n  `actmkt_ascription` varchar(1048576) NULL COMMENT \"\",\n  `actmkt_ascription_name` varchar(1048576) NULL COMMENT \"\",\n  `fenhang` varchar(1048576) NULL COMMENT \"\",\n  `fenhang_name` varchar(1048576) NULL COMMENT \"\",\n  `cust_group_name` varchar(1048576) NULL COMMENT \"\",\n  `strategy_type` varchar(1048576) NULL COMMENT \"\",\n  `scene_id` varchar(1048576) NULL COMMENT \"\",\n  `campaign_id` varchar(1048576) NULL COMMENT \"\",\n  `item_index_pdl` varchar(1048576) NULL COMMENT \"\",\n  `position_id` varchar(1048576) NULL COMMENT \"\",\n  `label_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `msg_type` varchar(1048576) NULL COMMENT \"\",\n  `channel_scene_id` varchar(1048576) NULL COMMENT \"\",\n  `dt` varchar(1048576) NULL COMMENT \"\"\n) ENGINE=HIVE \nPROPERTIES (\n\"database\" = \"test_db\",\n\"table\" = \"tbl_b\",\n\"resource\" = \"hive\"\n);",
    "test_db.tbl_c":"CREATE EXTERNAL TABLE `tbl_c` (\n  `becif_no` varchar(1048576) NULL COMMENT \"\",\n  `credit_act_flag` varchar(1048576) NULL COMMENT \"\",\n  `asset_level_manage` varchar(1048576) NULL COMMENT \"\",\n  `payroll_flag` varchar(1048576) NULL COMMENT \"\",\n  `sales_new_cust` varchar(1048576) NULL COMMENT \"\",\n  `if_one_acct_cust` varchar(1048576) NULL COMMENT \"\",\n  `have_erleihu` varchar(1048576) NULL COMMENT \"\",\n  `xyk_acct_open_date` varchar(1048576) NULL COMMENT \"\",\n  `first_xykjh_date` varchar(1048576) NULL COMMENT \"\",\n  `dat_cust_open` varchar(1048576) NULL COMMENT \"\",\n  `p_value_new1` varchar(1048576) NULL COMMENT \"\",\n  `age_flag4` varchar(1048576) NULL COMMENT \"\",\n  `prof2` varchar(1048576) NULL COMMENT \"\",\n  `org_id_pms` varchar(1048576) NULL COMMENT \"\",\n  `branch03_name` varchar(1048576) NULL COMMENT \"\",\n  `branch02_name` varchar(1048576) NULL COMMENT \"\",\n  `zt_kh_flag` varchar(1048576) NULL COMMENT \"\",\n  `recent_act_date` varchar(1048576) NULL COMMENT \"\",\n  `recent_trans_date` varchar(1048576) NULL COMMENT \"\",\n  `recent_trans_rtl_date` varchar(1048576) NULL COMMENT \"\",\n  `trans_first_date` varchar(1048576) NULL COMMENT \"\",\n  `gdqy_flag` varchar(1048576) NULL COMMENT \"\",\n  `gdwy_flag` varchar(1048576) NULL COMMENT \"\",\n  `gd5wy_flag` varchar(1048576) NULL COMMENT \"\",\n  `xj_l_flag` varchar(1048576) NULL COMMENT \"\",\n  `qr_l_flag` varchar(1048576) NULL COMMENT \"\",\n  `cust_manager_flag` varchar(1048576) NULL COMMENT \"\",\n  `jj_new_flag` varchar(1048576) NULL COMMENT \"\",\n  `fwdk_flag` varchar(1048576) NULL COMMENT \"\",\n  `is_car_flag` varchar(1048576) NULL COMMENT \"\",\n  `branch05_name` varchar(1048576) NULL COMMENT \"\",\n  `dt` varchar(1048576) NULL COMMENT \"\"\n) ENGINE=HIVE \nPROPERTIES (\n\"database\" = \"test_db\",\n\"table\" = \"tbl_c\",\n\"resource\" = \"hive\"\n);",
    "test_db.tbl_d":"CREATE EXTERNAL TABLE `tbl_d` (\n  `order_id` varchar(1048576) NULL COMMENT \"\",\n  `becif_no` varchar(1048576) NULL COMMENT \"\",\n  `trace_id` varchar(1048576) NULL COMMENT \"\",\n  `event_type` varchar(1048576) NULL COMMENT \"\",\n  `prod_id` varchar(1048576) NULL COMMENT \"\",\n  `prod1` varchar(1048576) NULL COMMENT \"\",\n  `prod2` varchar(1048576) NULL COMMENT \"\",\n  `prod3` varchar(1048576) NULL COMMENT \"\",\n  `channel_id` varchar(1048576) NULL COMMENT \"\",\n  `channel_name` varchar(1048576) NULL COMMENT \"\",\n  `channel_ato` varchar(1048576) NULL COMMENT \"\",\n  `event_time` varchar(1048576) NULL COMMENT \"\",\n  `event_amt` int(11) NULL COMMENT \"\",\n  `event_cnt` int(11) NULL COMMENT \"\",\n  `strategy_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `scene_id` varchar(1048576) NULL COMMENT \"\",\n  `serialno` varchar(1048576) NULL COMMENT \"\",\n  `data_date` varchar(1048576) NULL COMMENT \"\",\n  `talk_duration` int(11) NULL COMMENT \"\",\n  `dt` varchar(1048576) NULL COMMENT \"\"\n) ENGINE=HIVE \nPROPERTIES (\n\"database\" = \"test_db\",\n\"table\" = \"tbl_d\",\n\"resource\" = \"hive\"\n);",
    "test_db.tbl_b":"CREATE EXTERNAL TABLE `tbl_b` (\n  `trace_id` varchar(1048576) NULL COMMENT \"\",\n  `strategy_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `page_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `module_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `product_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `team_indicator_code` varchar(1048576) NULL COMMENT \"\",\n  `task_indicator_code` varchar(1048576) NULL COMMENT \"\",\n  `log_type` varchar(1048576) NULL COMMENT \"\",\n  `travel_code` varchar(1048576) NULL COMMENT \"\",\n  `node_code` varchar(1048576) NULL COMMENT \"\",\n  `travel_team_indicator_code` varchar(1048576) NULL COMMENT \"\",\n  `travel_task_indicator_code` varchar(1048576) NULL COMMENT \"\",\n  `node_type` varchar(1048576) NULL COMMENT \"\",\n  `big_type` varchar(1048576) NULL COMMENT \"\",\n  `batch_id` varchar(1048576) NULL COMMENT \"\",\n  `actmkt_ascription` varchar(1048576) NULL COMMENT \"\",\n  `actmkt_ascription_name` varchar(1048576) NULL COMMENT \"\",\n  `fenhang` varchar(1048576) NULL COMMENT \"\",\n  `fenhang_name` varchar(1048576) NULL COMMENT \"\",\n  `cust_group_name` varchar(1048576) NULL COMMENT \"\",\n  `strategy_type` varchar(1048576) NULL COMMENT \"\",\n  `scene_id` varchar(1048576) NULL COMMENT \"\",\n  `campaign_id` varchar(1048576) NULL COMMENT \"\",\n  `item_index_pdl` varchar(1048576) NULL COMMENT \"\",\n  `position_id` varchar(1048576) NULL COMMENT \"\",\n  `label_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `msg_type` varchar(1048576) NULL COMMENT \"\",\n  `channel_scene_id` varchar(1048576) NULL COMMENT \"\",\n  `dt` varchar(1048576) NULL COMMENT \"\"\n) ENGINE=HIVE \nPROPERTIES (\n\"database\" = \"test_db\",\n\"table\" = \"tbl_b\",\n\"resource\" = \"hive\"\n);",
    "test_db.tbl_e":"CREATE EXTERNAL TABLE `tbl_e` (\n  `team_indicator_code` varchar(1048576) NULL COMMENT \"\",\n  `team_indicator_name` varchar(1048576) NULL COMMENT \"\",\n  `task_indicator_code` varchar(1048576) NULL COMMENT \"\",\n  `task_indicator_name` varchar(1048576) NULL COMMENT \"\",\n  `strategy_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `page_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `module_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `product_id_pdl` varchar(1048576) NULL COMMENT \"\",\n  `product_type_pdl` varchar(1048576) NULL COMMENT \"\",\n  `item_index_pdl` varchar(1048576) NULL COMMENT \"\",\n  `cust_group_name` varchar(1048576) NULL COMMENT \"\",\n  `strategy_type` varchar(1048576) NULL COMMENT \"\",\n  `dt` varchar(1048576) NULL COMMENT \"\"\n) ENGINE=HIVE \nPROPERTIES (\n\"database\" = \"test_db\",\n\"table\" = \"tbl_e\",\n\"resource\" = \"hive\"\n);",
    "mv_35":"CREATE MATERIALIZED VIEW `mv_35` (`dt1`, `count_distinct_serialno`, `dt`, `dim2_strategy_id_pdl`, `f_data_date`, `dim2_task_indicator_code`, `dim3_node_code`, `dim2_item_index_pdl`, `dim3_travel_code`, `f_scene_id`, `dim2_cust_group_name`, `dim2_team_indicator_code`, `f_event_type`, `dim2_strategy_type`)\nPARTITION BY (str2date(`dt`, '%Y%m%d'))\nDISTRIBUTED BY RANDOM\nREFRESH DEFERRED MANUAL\nPROPERTIES (\n\"replicated_storage\" = \"true\",\n\"force_external_table_query_rewrite\" = \"CHECKED\",\n\"replication_num\" = \"1\",\n\"storage_medium\" = \"HDD\"\n)\nAS SELECT `f`.`dt` AS `dt1`, bitmap_union(to_bitmap(`f`.`becif_no`)) AS `count_distinct_serialno`, `f`.`dt`, `dim2`.`strategy_id_pdl` AS `dim2_strategy_id_pdl`, `f`.`data_date` AS `f_data_date`, `dim2`.`task_indicator_code` AS `dim2_task_indicator_code`, `dim3`.`node_code` AS `dim3_node_code`, `dim2`.`item_index_pdl` AS `dim2_item_index_pdl`, `dim3`.`travel_code` AS `dim3_travel_code`, `f`.`scene_id` AS `f_scene_id`, `dim2`.`cust_group_name` AS `dim2_cust_group_name`, `dim2`.`team_indicator_code` AS `dim2_team_indicator_code`, `f`.`event_type` AS `f_event_type`, `dim2`.`strategy_type` AS `dim2_strategy_type`\nFROM `hive`.`test_db`.`tbl_d` AS `f` LEFT OUTER JOIN `hive`.`test_db`.`tbl_b` AS `dim3` ON (`f`.`trace_id` = `dim3`.`trace_id`) AND (`f`.`dt` = `dim3`.`dt`) LEFT OUTER JOIN `hive`.`test_db`.`tbl_e` AS `dim2` ON (`f`.`strategy_id_pdl` = `dim2`.`strategy_id_pdl`) AND (`f`.`dt` = `dim2`.`dt`)\nGROUP BY `f`.`dt`, `dim2`.`strategy_id_pdl`, `f`.`data_date`, `dim2`.`task_indicator_code`, `dim3`.`node_code`, `dim2`.`item_index_pdl`, `dim3`.`travel_code`, `f`.`scene_id`, `dim2`.`cust_group_name`, `dim2`.`team_indicator_code`, `f`.`event_type`, `dim2`.`strategy_type`;"
  },
  "hms_table":{
    "hive%test_db%tbl_b":[
      {
        "type":"hive"
      },
      "{\"OutputRowCount\":\"1.0\",\"PartitionColumns\":[\"dt\"],\"DataColumns\":[\"trace_id\",\"strategy_id_pdl\",\"page_id_pdl\",\"module_id_pdl\",\"product_id_pdl\",\"team_indicator_code\",\"task_indicator_code\",\"log_type\",\"travel_code\",\"node_code\",\"travel_team_indicator_code\",\"travel_task_indicator_code\",\"node_type\",\"big_type\",\"batch_id\",\"actmkt_ascription\",\"actmkt_ascription_name\",\"fenhang\",\"fenhang_name\",\"cust_group_name\",\"strategy_type\",\"scene_id\",\"campaign_id\",\"item_index_pdl\",\"position_id\",\"label_id_pdl\",\"msg_type\",\"channel_scene_id\"],\"PartitionNames\":[]}"
    ],
    "hive%test_db%tbl_e":[
      {
        "type":"hive"
      },
      "{\"OutputRowCount\":\"0.0\",\"PartitionColumns\":[\"dt\"],\"DataColumns\":[\"team_indicator_code\",\"team_indicator_name\",\"task_indicator_code\",\"task_indicator_name\",\"strategy_id_pdl\",\"page_id_pdl\",\"module_id_pdl\",\"product_id_pdl\",\"product_type_pdl\",\"item_index_pdl\",\"cust_group_name\",\"strategy_type\"],\"PartitionNames\":[]}"
    ],
    "hive%test_db%tbl_c":[
      {
        "type":"hive"
      },
      "{\"OutputRowCount\":\"1.0\",\"PartitionColumns\":[\"dt\"],\"DataColumns\":[\"becif_no\",\"credit_act_flag\",\"asset_level_manage\",\"payroll_flag\",\"sales_new_cust\",\"if_one_acct_cust\",\"have_erleihu\",\"xyk_acct_open_date\",\"first_xykjh_date\",\"dat_cust_open\",\"p_value_new1\",\"age_flag4\",\"prof2\",\"org_id_pms\",\"branch03_name\",\"branch02_name\",\"zt_kh_flag\",\"recent_act_date\",\"recent_trans_date\",\"recent_trans_rtl_date\",\"trans_first_date\",\"gdqy_flag\",\"gdwy_flag\",\"gd5wy_flag\",\"xj_l_flag\",\"qr_l_flag\",\"cust_manager_flag\",\"jj_new_flag\",\"fwdk_flag\",\"is_car_flag\",\"branch05_name\"],\"PartitionNames\":[]}"
    ],
    "hive%test_db%tbl_a":[
      {
        "type":"hive"
      },
      "{\"OutputRowCount\":\"1.0\",\"PartitionColumns\":[\"dt\"],\"DataColumns\":[\"becif_no\",\"type\",\"strategy_id\",\"strategy_id_pdl\",\"uv\",\"data_year\",\"data_month\",\"data_date\",\"page_id_pdl\",\"page_name_pdl\",\"label_id_pdl\",\"label_name_pdl\",\"module_id_pdl\",\"module_name_pdl\",\"strategy_item_id\",\"strategy_item_type\",\"strategy_item_name\",\"pv\",\"channel_id_pdl\",\"channel_name_pdl\",\"product_id_pdl\",\"product_type\",\"product_name\",\"platform_type\",\"event_type\",\"channel_id\",\"prod1\",\"prod2\",\"prod3\",\"travel_code\",\"node_code\",\"batch_id\",\"scene_id\",\"campaign_id\",\"item_index_pdl\",\"position_id\",\"trace_id\",\"channel_ato\",\"strategy_type\",\"team_indicator_code\",\"task_indicator_code\",\"cust_group_name\",\"event_time\"],\"PartitionNames\":[]}"
    ],
    "hive%test_db%tbl_d":[
      {
        "type":"hive"
      },
      "{\"OutputRowCount\":\"0.0\",\"PartitionColumns\":[\"dt\"],\"DataColumns\":[\"order_id\",\"becif_no\",\"trace_id\",\"event_type\",\"prod_id\",\"prod1\",\"prod2\",\"prod3\",\"channel_id\",\"channel_name\",\"channel_ato\",\"event_time\",\"event_amt\",\"event_cnt\",\"strategy_id_pdl\",\"scene_id\",\"serialno\",\"data_date\",\"talk_duration\"],\"PartitionNames\":[]}"
    ]
  },
  "table_row_count":{

  },
  "column_statistics":{
    "test_db.tbl_b":{
      "dt":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "trace_id":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "strategy_id_pdl":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "test_db.tbl_a":{
      "dt":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "trace_id":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "becif_no":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "test_db.tbl_c":{
      "dt":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "strategy_id_pdl":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "trace_id":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "becif_no":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "test_db.tbl_d":{
      "dt":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "trace_id":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "strategy_id_pdl":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "becif_no":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "test_db.tbl_e":{
      "dt":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "strategy_id_pdl":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "trace_id":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "becif_no":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    }
  },
  "explain_info":"PLAN FRAGMENT 0(F10)\n  Output Exprs:106: count | 46: strategy_id_pdl\n  Input Partition: UNPARTITIONED\n  RESULT SINK\n\n  15:EXCHANGE\n     distribution type: GATHER\n     limit: 51000\n     cardinality: 1\n\nPLAN FRAGMENT 1(F09)\n\n  Input Partition: HASH_PARTITIONED: 46: strategy_id_pdl\n  OutPut Partition: UNPARTITIONED\n  OutPut Exchange Id: 15\n\n  14:AGGREGATE (update finalize)\n  |  aggregate: count[([1: becif_no, VARCHAR, true]); args: VARCHAR; result: BIGINT; args nullable: true; result nullable: false]\n  |  group by: [46: strategy_id_pdl, VARCHAR, true]\n  |  hasNullableGenerateChild: true\n  |  limit: 51000\n  |  cardinality: 1\n  |  column statistics: \n  |  * strategy_id_pdl-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * count-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  \n  13:AGGREGATE (merge serialize)\n  |  group by: [1: becif_no, VARCHAR, true], [46: strategy_id_pdl, VARCHAR, true]\n  |  hasNullableGenerateChild: true\n  |  cardinality: 1\n  |  column statistics: \n  |  * becif_no-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * strategy_id_pdl-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  \n  12:EXCHANGE\n     distribution type: SHUFFLE\n     partition exprs: [46: strategy_id_pdl, VARCHAR, true]\n     cardinality: 1\n\nPLAN FRAGMENT 2(F08)\n\n  Input Partition: HASH_PARTITIONED: 45: trace_id, 73: dt\n  OutPut Partition: HASH_PARTITIONED: 46: strategy_id_pdl\n  OutPut Exchange Id: 12\n\n  11:AGGREGATE (update serialize)\n  |  STREAMING\n  |  group by: [1: becif_no, VARCHAR, true], [46: strategy_id_pdl, VARCHAR, true]\n  |  hasNullableGenerateChild: true\n  |  cardinality: 1\n  |  column statistics: \n  |  * becif_no-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * strategy_id_pdl-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  \n  10:Project\n  |  output columns:\n  |  1 <-> [1: becif_no, VARCHAR, true]\n  |  46 <-> [46: strategy_id_pdl, VARCHAR, true]\n  |  hasNullableGenerateChild: true\n  |  cardinality: 1\n  |  column statistics: \n  |  * becif_no-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * strategy_id_pdl-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  \n  9:HASH JOIN\n  |  join op: INNER JOIN (PARTITIONED)\n  |  equal join conjunct: [45: trace_id, VARCHAR, true] = [37: trace_id, VARCHAR, true]\n  |  equal join conjunct: [73: dt, VARCHAR, true] = [44: dt, VARCHAR, true]\n  |  build runtime filters:\n  |  - filter_id = 0, build_expr = (37: trace_id), remote = false\n  |  - filter_id = 1, build_expr = (44: dt), remote = false\n  |  output columns: 1, 46\n  |  can local shuffle: true\n  |  cardinality: 1\n  |  column statistics: \n  |  * becif_no-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * dt-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * strategy_id_pdl-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * becif_no-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * dt-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  \n  |----8:EXCHANGE\n  |       distribution type: SHUFFLE\n  |       partition exprs: [37: trace_id, VARCHAR, true], [44: dt, VARCHAR, true]\n  |       cardinality: 1\n  |    \n  1:EXCHANGE\n     distribution type: SHUFFLE\n     partition exprs: [45: trace_id, VARCHAR, true], [73: dt, VARCHAR, true]\n     cardinality: 1\n     probe runtime filters:\n     - filter_id = 0, probe_expr = (45: trace_id)\n     - filter_id = 1, probe_expr = (73: dt)\n\nPLAN FRAGMENT 3(F06)\n\n  Input Partition: HASH_PARTITIONED: 1: becif_no, 44: dt\n  OutPut Partition: HASH_PARTITIONED: 37: trace_id, 44: dt\n  OutPut Exchange Id: 08\n\n  7:Project\n  |  output columns:\n  |  1 <-> [1: becif_no, VARCHAR, true]\n  |  37 <-> [37: trace_id, VARCHAR, true]\n  |  44 <-> [44: dt, VARCHAR, true]\n  |  hasNullableGenerateChild: true\n  |  cardinality: 1\n  |  column statistics: \n  |  * becif_no-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * trace_id-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * dt-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  \n  6:HASH JOIN\n  |  join op: LEFT OUTER JOIN (PARTITIONED)\n  |  equal join conjunct: [1: becif_no, VARCHAR, true] = [74: becif_no, VARCHAR, true]\n  |  equal join conjunct: [44: dt, VARCHAR, true] = [105: dt, VARCHAR, true]\n  |  output columns: 1, 37, 44\n  |  can local shuffle: false\n  |  cardinality: 1\n  |  column statistics: \n  |  * becif_no-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * trace_id-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * dt-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * becif_no-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  * dt-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n  |  \n  |----5:EXCHANGE\n  |       distribution type: SHUFFLE\n  |       partition exprs: [74: becif_no, VARCHAR, true], [105: dt, VARCHAR, true]\n  |       cardinality: 1\n  |    \n  3:EXCHANGE\n     distribution type: SHUFFLE\n     partition exprs: [1: becif_no, VARCHAR, true], [44: dt, VARCHAR, true]\n     cardinality: 1\n\nPLAN FRAGMENT 4(F04)\n\n  Input Partition: RANDOM\n  OutPut Partition: HASH_PARTITIONED: 74: becif_no, 105: dt\n  OutPut Exchange Id: 05\n\n  4:HdfsScanNode\n     TABLE: tbl_c\n     PARTITION PREDICATES: 105: dt >= '20231007', 105: dt <= '20231105'\n     partitions=30/356\n     avgRowSize=2.0\n     numNodes=0\n     cardinality: 1\n     column statistics: \n     * becif_no-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n     * dt-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n\nPLAN FRAGMENT 5(F02)\n\n  Input Partition: RANDOM\n  OutPut Partition: HASH_PARTITIONED: 1: becif_no, 44: dt\n  OutPut Exchange Id: 03\n\n  2:HdfsScanNode\n     TABLE: tbl_a\n     PARTITION PREDICATES: 44: dt >= '20231007', 44: dt <= '20231105'\n     partitions=30/325\n     avgRowSize=3.0\n     numNodes=0\n     cardinality: 1\n     column statistics: \n     * becif_no-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n     * trace_id-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n     * dt-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n\nPLAN FRAGMENT 6(F00)\n\n  Input Partition: RANDOM\n  OutPut Partition: HASH_PARTITIONED: 45: trace_id, 73: dt\n  OutPut Exchange Id: 01\n\n  0:HdfsScanNode\n     TABLE: tbl_b\n     PARTITION PREDICATES: 73: dt >= '20231007', 73: dt <= '20231105'\n     NON-PARTITION PREDICATES: (46: strategy_id_pdl != '') OR (46: strategy_id_pdl IS NOT NULL)\n     partitions=30/539\n     avgRowSize=3.0\n     numNodes=0\n     cardinality: 1\n     column statistics: \n     * trace_id-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n     * strategy_id_pdl-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n     * dt-->[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN\n",
  "session_variables":"{\"partial_update_mode\":\"auto\",\"cbo_cte_reuse\":true,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"enable_connector_adaptive_io_tasks\":true,\"tx_isolation\":\"REPEATABLE-READ\",\"enable_hive_metadata_cache_with_insert\":false,\"cbo_cte_reuse_rate_v2\":1.15,\"character_set_results\":\"utf8\",\"enable_iceberg_column_statistics\":true,\"enable_count_star_optimization\":true,\"global_runtime_filter_build_min_size\":131072,\"enable_iceberg_identity_column_optimize\":true,\"query_excluding_mv_names\":\"\",\"enable_rewrite_simple_agg_to_meta_scan\":false,\"enable_adaptive_sink_dop\":true,\"consistent_hash_virtual_number\":32,\"enable_profile\":true,\"load_mem_limit\":0,\"cbo_eq_base_type\":\"varchar\",\"large_decimal_underlying_type\":\"panic\",\"sql_safe_updates\":0,\"runtime_filter_early_return_selectivity\":0.05,\"enable_local_shuffle_agg\":true,\"disable_function_fold_constants\":false,\"select_ratio_threshold\":0.15,\"query_delivery_timeout\":300,\"collation_database\":\"utf8_general_ci\",\"spill_mem_table_size\":104857600,\"cbo_use_lock_db\":false,\"new_planner_agg_stage\":0,\"hash_join_interpolate_passthrough\":false,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"enable_materialized_view_plan_cache\":true,\"spill_operator_max_bytes\":1048576000,\"cbo_max_reorder_node_use_dp\":10,\"enable_hive_column_stats\":true,\"enable_async_profile\":true,\"enable_groupby_use_output_alias\":false,\"global_runtime_filter_wait_timeout\":20,\"forward_to_leader\":false,\"count_distinct_column_buckets\":1024,\"cross_join_cost_penalty\":1000000,\"query_cache_agg_cardinality_limit\":5000000,\"enable_pipeline_query_statistic\":true,\"cboPushDownAggregateMode_v1\":-1,\"window_partition_mode\":1,\"enable_deliver_batch_fragments\":true,\"enable_tablet_internal_parallel_v2\":true,\"interpolate_passthrough\":true,\"enable_incremental_mv\":false,\"cbo_push_down_topn_limit\":0,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"max_pipeline_dop\":64,\"broadcast_right_table_scale_factor\":10,\"materialized_view_rewrite_mode\":\"DEFAULT\",\"enable_simplify_case_when\":true,\"runtime_join_filter_push_down_limit\":1024000,\"big_query_log_cpu_second_threshold\":480,\"div_precision_increment\":4,\"runtime_adaptive_dop_max_block_rows_per_driver_seq\":16384,\"log_rejected_record_num\":0,\"cbo_push_down_distinct_below_window\":true,\"sql_mode_v2\":32,\"prefer_cte_rewrite\":false,\"hdfs_backend_selector_scan_range_shuffle\":false,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"hive_partition_stats_sample_size\":3000,\"enable_mv_planner\":false,\"enable_collect_table_level_scan_stats\":true,\"profile_timeout\":2,\"cbo_push_down_aggregate\":\"global\",\"spill_encode_level\":7,\"enable_query_dump\":false,\"global_runtime_filter_build_max_size\":67108864,\"enable_rewrite_sum_by_associative_rule\":true,\"query_cache_hot_partition_num\":3,\"enable_prune_complex_types\":true,\"query_cache_type\":0,\"max_parallel_scan_instance_num\":-1,\"query_cache_entry_max_rows\":409600,\"enable_mv_optimizer_trace_log\":false,\"connector_io_tasks_per_scan_operator\":16,\"enable_materialized_view_union_rewrite\":true,\"sql_quote_show_create\":true,\"scan_or_to_union_threshold\":50000000,\"enable_exchange_pass_through\":true,\"runtime_profile_report_interval\":10,\"query_cache_entry_max_bytes\":4194304,\"enable_partition_column_value_only_optimization\":true,\"enable_iceberg_ndv\":true,\"enable_exchange_perf\":false,\"workgroup_id\":0,\"enable_rewrite_groupingsets_to_union_all\":false,\"transmission_compression_type\":\"NO_COMPRESSION\",\"interactive_timeout\":3600,\"use_page_cache\":true,\"big_query_log_scan_bytes_threshold\":10737418240,\"collation_server\":\"utf8_general_ci\",\"cbo_decimal_cast_string_strict\":true,\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"spill_mode\":\"auto\",\"enable_query_debug_trace\":false,\"enable_show_all_variables\":false,\"full_sort_max_buffered_bytes\":16777216,\"wait_timeout\":28800,\"enable_query_tablet_affinity\":false,\"transmission_encode_level\":7,\"query_including_mv_names\":\"\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"enable_load_profile\":false,\"enable_plan_validation\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"global_runtime_filter_rpc_http_min_size\":67108864,\"cbo_enable_low_cardinality_optimize\":true,\"scan_use_query_mem_ratio\":0.3,\"new_planner_optimize_timeout\":3000,\"enable_outer_join_reorder\":true,\"force_schedule_local\":false,\"hudi_mor_force_jni_reader\":false,\"full_sort_late_materialization\":false,\"cbo_enable_greedy_join_reorder\":true,\"range_pruner_max_predicate\":100,\"enable_rbo_table_prune\":false,\"spillable_operator_mask\":-1,\"rpc_http_min_size\":2147482624,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"scan_or_to_union_limit\":4,\"enable_cbo_table_prune\":false,\"enable_parallel_merge\":true,\"nested_mv_rewrite_max_level\":3,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"enable_persistent_index_by_default\":false,\"hash_join_push_down_right_table\":true,\"pipeline_sink_dop\":0,\"broadcast_row_limit\":15000000,\"enable_populate_block_cache\":true,\"exec_mem_limit\":2147483648,\"enable_sort_aggregate\":false,\"query_cache_force_populate\":false,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_rule_based_materialized_view_rewrite\":true,\"global_runtime_filter_rpc_timeout\":400,\"connector_scan_use_query_mem_ratio\":0.3,\"net_buffer_length\":16384,\"cbo_prune_subfield\":true,\"full_sort_max_buffered_rows\":1024000,\"query_timeout\":300,\"connector_io_tasks_slow_io_latency_ms\":50,\"cbo_max_reorder_node\":50,\"enable_distinct_column_bucketization\":false,\"enable_big_query_log\":true,\"analyze_mv\":\"sample\",\"runtime_filter_scan_wait_time\":20,\"enable_sync_materialized_view_rewrite\":true,\"prefer_compute_node\":false,\"enable_strict_type\":false,\"enable_table_prune_on_update\":false,\"group_concat_max_len\":1024,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"big_query_profile_second_threshold\":0,\"enable_filter_unused_columns_in_scan_stage\":true,\"enable_scan_block_cache\":false,\"enable_materialized_view_single_table_view_delta_rewrite\":false,\"enable_prune_complex_types_in_unnest\":true,\"auto_increment_increment\":1,\"sql_dialect\":\"StarRocks\",\"big_query_log_scan_rows_threshold\":1000000000,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":true,\"enable_runtime_adaptive_dop\":false,\"cbo_cte_max_limit\":10,\"storage_engine\":\"olap\",\"enable_optimizer_trace_log\":false,\"spill_operator_min_bytes\":10485760,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"enable_materialized_view_view_delta_rewrite\":true,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"spill_mem_table_num\":2,\"enable_spill\":false,\"enable_materialized_view_rewrite_greedy_mode\":false,\"pipeline_dop\":0,\"single_node_exec_plan\":false,\"join_implementation_mode_v2\":\"auto\",\"sql_select_limit\":9223372036854775807,\"enable_materialized_view_rewrite\":true,\"statistic_collect_parallel\":1,\"hdfs_backend_selector_hash_algorithm\":\"consistent\",\"enable_expr_prune_partition\":true,\"enable_topn_runtime_filter\":true,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"default_table_compression\":\"lz4_frame\",\"runtime_adaptive_dop_max_output_amplification_factor\":0,\"choose_execute_instances_mode\":\"ADAPTIVE_DECREASE\",\"innodb_read_only\":true,\"spill_mem_limit_threshold\":0.8,\"cbo_reorder_threshold_use_exhaustive\":6,\"enable_predicate_reorder\":false,\"enable_query_cache\":false,\"max_allowed_packet\":33554432,\"time_zone\":\"Asia/Shanghai\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"cbo_use_nth_exec_plan\":0,\"io_tasks_per_scan_operator\":4,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":true,\"cbo_derive_range_join_predicate\":false,\"allow_default_partition\":false}",
  "be_number":20,
  "be_core_stat":{
    "numOfHardwareCoresPerBe":"{\"48000\":64,\"48001\":64,\"48002\":64,\"47500\":64,\"47989\":64,\"47990\":64,\"47991\":64,\"47992\":64,\"10009\":64,\"47993\":64,\"47994\":64,\"47995\":64,\"47996\":64,\"10013\":64,\"47997\":64,\"10014\":64,\"10142\":64,\"47998\":64,\"10015\":64,\"47999\":64}",
    "cachedAvgNumOfHardwareCores":64
  },
  "exception":[

  ],
  "version":"branch-3.1",
  "commit_version":"101a3ba"
}